April 28, 2021

S&P 500 vs COVID IN U.S

  • This presentation shows how S&P 500 reacts to covid cases in United States

  • This analysis is only valid for United States.

  • S&P 500 Data was collected from finance.yahoo.com

  • covid data was collected from covidtracking.com/data

GRAPH S&P 500 PRICE VS INCREASE IN COVID CASES

CODEBOOK AND DATA MANIPULATION

  • positiveIncrease: The daily increase in API field positive, which measures Cases (confirmed plus probable) calculated based on the previous day’s value.

  • Open: The price at which S&P500 Opened.

  • On the Y-axis we have S&P500 Pricea and scaled value of PositiveIncrease.

  • On the X-axis we have dates from Jan 13, 2020 to March 5th, 2021.

  • P.S: In order to fit the covid data in the graph, the covid data was scaled down by dividing the positiveIncrease by 50.

CONCLUSION

  • From the data, we can see a drop in S&P500 only when covid cases first started to rise

  • Other than that, covid does not seem to have much effect on S&P500.